pg_dump restore as transaction?
От | Owen Hartnett |
---|---|
Тема | pg_dump restore as transaction? |
Дата | |
Msg-id | p0624080ec559cdec47b2@[192.168.0.107] обсуждение исходный текст |
Ответ на | Re: Detecting changes to certain fields in 'before update' trigger functions ("Richard Broersma" <richard.broersma@gmail.com>) |
Ответы |
Re: pg_dump restore as transaction?
Re: pg_dump restore as transaction? Re: pg_dump restore as transaction? |
Список | pgsql-general |
If my perusal of the sql generated by pg_dump is correct, then it doesn't appear that it's wrapped in a transaction, and thus might be able to only complete a partial restore? Or does psql myDatabase <mypg_dumpfile wrap the file stream in a transaction? If not, is there a reason why it can't be done so (some process that cannot be run as a transaction inside the file)? Or should I just add begin and commit statements at the beginning and end of file? I want to provide a mechanized daily update of one schema into a differently named database, and I'd like it to rollback if if fails. -Owen
В списке pgsql-general по дате отправления: